Abstract: In order to solve the problem that the PostgreSQL starts many processes which takes up a lot of system resources, this paper presents an improved method for PostgreSQL storage engine, that is, using the thread pool wake-up call to replace the original PostgreSQL multi-process communication mechanism, so as to solve the problem that the PostgreSQL takes up a lot of system resources while starting large number of processes. Experimental results show that the improved method of PostgreSQL storage engine thread pool can be a good solution to the problems of system resources and improve the implementation efficiency of database.

Key words: PostgreSQL, database performance test, database performance optimization, multi-threaded optimization